C/C++ Users Group Library 1996 July/C-C++ Users Group Library July 1996.iso/listings/v_02_08/2n08061b

Text File | 1991-05-12 | 452 b | 19 lines

CREATE VIEW apptally(region#, appcount, fundcount)
AS SELECT region#, COUNT(appdate), 0
     FROM Loans
    WHERE appdate BETWEEN 1991-Apr-01 AND 1991-Apr-30
  GROUP BY region#;
CREATE VIEW fundtally(region#, appcount, fundcount)
AS SELECT region#, 0, COUNT(funddate)
     FROM Loans
    WHERE funddate BETWEEN 1991-Apr-01 AND 1991-Apr-30
  GROUP BY region#;
SELECT * FROM apptally
UNION ALL
SELECT * FROM fundtally
ORDER BY 1;